Skip to main content

Snowflake Integration Setup

Snowflake Account Configuration​

1. Create nOps Database, Role, User, and Warehouse​

-- Login as ACCOUNTADMIN
USE ROLE ACCOUNTADMIN;

-- Create a dedicated database, role, user, and warehouse
CREATE DATABASE nops;
CREATE ROLE nops;
CREATE USER nops;
GRANT ROLE nops TO USER nops;
GRANT ROLE nops TO ROLE accountadmin;

CREATE WAREHOUSE nops;
GRANT ALL ON WAREHOUSE nops TO ROLE nops;

-- Configure the user
ALTER USER nops SET DEFAULT_WAREHOUSE = nops, DEFAULT_ROLE = nops;
ALTER USER nops SET PASSWORD = 'YwA*6f1!';

-- Grant access to Snowflake shared usage views
GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE nops;

2. Create Views for nOps Integration​

USE WAREHOUSE nops;

CREATE VIEW nops.public.query_history AS
  SELECT * FROM snowflake.account_usage.query_history;

CREATE VIEW nops.public.warehouse_metering_history AS
  SELECT * FROM snowflake.organization_usage.warehouse_metering_history;

CREATE VIEW nops.public.usage_in_currency_daily AS
  SELECT * FROM snowflake.organization_usage.usage_in_currency_daily;

-- Grant access to the NOPS schema and views
GRANT USAGE ON DATABASE nops TO ROLE nops;
GRANT USAGE ON SCHEMA nops.public TO ROLE nops;
GRANT SELECT ON ALL VIEWS IN SCHEMA nops.public TO ROLE nops;

3. IP Allowlist Considerations​

If your Snowflake cluster uses an IP allow list, add the following IP:

  • 52.11.169.55

nOps Integration Steps​

1. Prepare Snowflake Server URL​

  • Format: <account_identifier>.<region>.snowflakecomputing.com
  • Example: xy12345.us-east-1.snowflakecomputing.com

2. Navigate to nOps Integration​

  1. Access your Business Context+ Integrations
  2. Choose "Snowflake"

3. Configure Integration Details​

Fill in the following information:

  • Server URL
  • Password

4. Verify Integration​

-- Test as the nops role
USE ROLE nops;
SELECT * FROM nops.public.query_history LIMIT 1;

Troubleshooting​

Common Integration Issues​

  1. Permission Errors

    • Ensure the nops user has been granted the correct roles
    • Verify ACCOUNTADMIN privileges for initial setup

  2. Connection Problems

    • Double-check account identifier and region
    • Confirm network connectivity
    • Validate IP allowlist configuration

  3. Data Access Issues

    • Verify view creation and permissions
    • Check that shared usage views are accessible

Support​

If you encounter persistent issues, contact nOps support with:

  • Snowflake account identifier
  • Error messages
  • Configuration details

Best Practices​

  • Use a dedicated role and user for nOps integration
  • Regularly review and rotate credentials
  • Monitor integration performance and data sync